package com.oceanread.cn.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oceanread.cn.entity.Pipeline;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface PipelineMapper extends BaseMapper<Pipeline> {
   List<Pipeline> getall();
   List<Pipeline> query(@Param("key") String key, @Param("value") String value);
   List<Pipeline> equal(@Param("key") String key, @Param("value") String value);
   List<Pipeline> equal2(@Param("key") String key, @Param("value") String value,@Param("key2") String key2, @Param("value2") String value2);

   int insert(@Param("PrjCode")String PrjCode, @Param("Name")String Name,
              @Param("Type")String Type, @Param("IDLine")String IDLine,
              @Param("IDPoint")String IDPoint, @Param("North")String North,
              @Param("East")String East, @Param("Lat")String Lat,
              @Param("Lon")String Lon, @Param("Distance")String Distance,
              @Param("DisZ")String DisZ, @Param("Angle")String Angle,
              @Param("Note")String Note, @Param("Line")String Line,
              @Param("pointOrder")Integer pointOrder,
              @Param("length")String length,
              @Param("depth")String depth
   );

   Integer update(@Param("SYSID") int SYSID,
                  @Param("PrjCode")String PrjCode, @Param("Name")String Name,
                  @Param("Type")String Type, @Param("IDLine")String IDLine,
                  @Param("IDPoint")String IDPoint, @Param("North")String North,
                  @Param("East")String East, @Param("Lat")String Lat,
                  @Param("Lon")String Lon, @Param("Distance")String Distance,
                  @Param("DisZ")String DisZ, @Param("Angle")String Angle,
                  @Param("Note")String Note, @Param("Line")String Line,
                  @Param("pointOrder")Integer pointOrder,
                  @Param("length")String length, @Param("depth")String depth
   );

   Integer delete(@Param("SYSID") int id);


   List<Pipeline> query1(@Param("start") int start, @Param("end") int end, @Param("key") String key, @Param("value") String value);

   Integer getnumquery(@Param("key")String key, @Param("value")String value);

   Integer getnum();

   List<Pipeline> findall(@Param("start") int start, @Param("end") int end);


   List<Pipeline> getLine(@Param("PrjCode")String PrjCode);

   List<Pipeline> getPoint(@Param("PrjCode")String PrjCode,@Param("IDLine")String IDLine);

   List<Pipeline> getLine_Page(@Param("PrjCode")String PrjCode,@Param("start") int start, @Param("end") int end);
   Integer getLine_Num(@Param("PrjCode")String PrjCode);
   List<Pipeline> getPoint_Page(@Param("PrjCode")String PrjCode,@Param("IDLine")String IDLine,@Param("start") int start, @Param("end") int end);
   Integer getPoint_Num(@Param("PrjCode")String PrjCode,@Param("IDLine")String IDLine);

}
